Dataset statistics
| Number of variables | 43 |
|---|---|
| Number of observations | 198910 |
| Missing cells | 2246072 |
| Missing cells (%) | 26.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 350.2 MiB |
| Average record size in memory | 1.8 KiB |
Variable types
| Text | 10 |
|---|---|
| Numeric | 13 |
| Categorical | 8 |
| DateTime | 7 |
| Boolean | 4 |
| Unsupported | 1 |
Structural Notification has constant value "True" | Constant |
Voluntary Soft-Story Retrofit has constant value "True" | Constant |
Fire Only Permit has constant value "True" | Constant |
Site Permit has constant value "True" | Constant |
Estimated Cost is highly overall correlated with Revised Cost | High correlation |
Existing Construction Type is highly overall correlated with Number of Existing Stories and 2 other fields | High correlation |
Existing Construction Type Description is highly overall correlated with Proposed Construction Type and 1 other fields | High correlation |
Existing Units is highly overall correlated with Proposed Units | High correlation |
Neighborhoods - Analysis Boundaries is highly overall correlated with Zipcode | High correlation |
Number of Existing Stories is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Number of Proposed Stories is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Permit Type is highly overall correlated with Permit Type Definition | High correlation |
Permit Type Definition is highly overall correlated with Permit Type | High correlation |
Plansets is highly overall correlated with Street Number Suffix | High correlation |
Proposed Construction Type is highly overall correlated with Existing Construction Type Description and 1 other fields | High correlation |
Proposed Construction Type Description is highly overall correlated with Existing Construction Type Description and 1 other fields | High correlation |
Proposed Units is highly overall correlated with Existing Units | High correlation |
Revised Cost is highly overall correlated with Estimated Cost | High correlation |
Street Number Suffix is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Zipcode is highly overall correlated with Neighborhoods - Analysis Boundaries | High correlation |
Permit Type Definition is highly imbalanced (83.5%) | Imbalance |
Street Number Suffix is highly imbalanced (59.2%) | Imbalance |
Street Suffix is highly imbalanced (69.9%) | Imbalance |
Current Status is highly imbalanced (60.4%) | Imbalance |
Existing Construction Type Description is highly imbalanced (60.4%) | Imbalance |
Street Number Suffix has 196694 (98.9%) missing values | Missing |
Street Suffix has 2768 (1.4%) missing values | Missing |
Unit has 169430 (85.2%) missing values | Missing |
Unit Suffix has 196949 (99.0%) missing values | Missing |
Issued Date has 14942 (7.5%) missing values | Missing |
Completed Date has 101715 (51.1%) missing values | Missing |
First Construction Document Date has 14948 (7.5%) missing values | Missing |
Structural Notification has 191988 (96.5%) missing values | Missing |
Number of Existing Stories has 42788 (21.5%) missing values | Missing |
Number of Proposed Stories has 42871 (21.6%) missing values | Missing |
Voluntary Soft-Story Retrofit has 198875 (> 99.9%) missing values | Missing |
Fire Only Permit has 180082 (90.5%) missing values | Missing |
Permit Expiration Date has 51884 (26.1%) missing values | Missing |
Estimated Cost has 38068 (19.1%) missing values | Missing |
Revised Cost has 6066 (3.0%) missing values | Missing |
Existing Use has 41117 (20.7%) missing values | Missing |
Existing Units has 51543 (25.9%) missing values | Missing |
Proposed Use has 42441 (21.3%) missing values | Missing |
Proposed Units has 50915 (25.6%) missing values | Missing |
Plansets has 37311 (18.8%) missing values | Missing |
TIDF Compliance has 198908 (> 99.9%) missing values | Missing |
Existing Construction Type has 43369 (21.8%) missing values | Missing |
Existing Construction Type Description has 43370 (21.8%) missing values | Missing |
Proposed Construction Type has 43165 (21.7%) missing values | Missing |
Proposed Construction Type Description has 43165 (21.7%) missing values | Missing |
Site Permit has 193550 (97.3%) missing values | Missing |
Estimated Cost is highly skewed (γ1 = 80.2643549) | Skewed |
Revised Cost is highly skewed (γ1 = 108.7016029) | Skewed |
Plansets is highly skewed (γ1 = 400.8420748) | Skewed |
Existing Construction Type is highly skewed (γ1 = 35.25093762) | Skewed |
Supervisor District is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unit has 21411 (10.8%) zeros | Zeros |
Revised Cost has 8514 (4.3%) zeros | Zeros |
Existing Units has 29135 (14.6%) zeros | Zeros |
Proposed Units has 26885 (13.5%) zeros | Zeros |
Plansets has 63247 (31.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-29 16:54:38.065797 |
|---|---|
| Analysis finished | 2024-08-29 16:57:03.436463 |
| Duration | 2 minutes and 25.37 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
Permit Number
Text
| Distinct | 181495 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.9 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.06327 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2200595 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 167272 ? |
|---|---|
| Unique (%) | 84.1% |
Sample
| 1st row | M788927 |
|---|---|
| 2nd row | 201305318356 |
| 3rd row | 201705106205 |
| 4th row | 201410279983 |
| 5th row | 201310280388 |
| Value | Count | Frequency (%) |
| 201602179765 | 101 | 0.1% |
| 201602179758 | 66 | < 0.1% |
| 201602179775 | 30 | < 0.1% |
| 201708165004 | 9 | < 0.1% |
| 201702239990 | 9 | < 0.1% |
| 201409166451 | 9 | < 0.1% |
| 201707061162 | 8 | < 0.1% |
| 201604285989 | 8 | < 0.1% |
| 201702099112 | 8 | < 0.1% |
| 201602179774 | 8 | < 0.1% |
| Other values (181485) | 198654 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 445644 | |
| 1 | 376248 | |
| 2 | 338899 | |
| 7 | 174090 | 7.9% |
| 6 | 150955 | 6.9% |
| 4 | 147674 | 6.7% |
| 3 | 145535 | 6.6% |
| 5 | 144933 | 6.6% |
| 8 | 130430 | 5.9% |
| 9 | 108922 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2200595 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 445644 | |
| 1 | 376248 | |
| 2 | 338899 | |
| 7 | 174090 | 7.9% |
| 6 | 150955 | 6.9% |
| 4 | 147674 | 6.7% |
| 3 | 145535 | 6.6% |
| 5 | 144933 | 6.6% |
| 8 | 130430 | 5.9% |
| 9 | 108922 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2200595 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 445644 | |
| 1 | 376248 | |
| 2 | 338899 | |
| 7 | 174090 | 7.9% |
| 6 | 150955 | 6.9% |
| 4 | 147674 | 6.7% |
| 3 | 145535 | 6.6% |
| 5 | 144933 | 6.6% |
| 8 | 130430 | 5.9% |
| 9 | 108922 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2200595 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 445644 | |
| 1 | 376248 | |
| 2 | 338899 | |
| 7 | 174090 | 7.9% |
| 6 | 150955 | 6.9% |
| 4 | 147674 | 6.7% |
| 3 | 145535 | 6.6% |
| 5 | 144933 | 6.6% |
| 8 | 130430 | 5.9% |
| 9 | 108922 | 4.9% |
Permit Type
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5222865 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 8 |
| Q3 | 8 |
| 95-th percentile | 8 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.457526 |
|---|---|
| Coefficient of variation (CV) | 0.19376103 |
| Kurtosis | 6.036264 |
| Mean | 7.5222865 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.79896 |
| Sum | 1496258 |
| Variance | 2.124382 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 178852 | |
| 3 | 14664 | 7.4% |
| 4 | 2892 | 1.5% |
| 2 | 950 | 0.5% |
| 6 | 600 | 0.3% |
| 7 | 511 | 0.3% |
| 1 | 350 | 0.2% |
| 5 | 91 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 350 | 0.2% |
| 2 | 950 | 0.5% |
| 3 | 14664 | 7.4% |
| 4 | 2892 | 1.5% |
| 5 | 91 | < 0.1% |
| 6 | 600 | 0.3% |
| 7 | 511 | 0.3% |
| 8 | 178852 |
| Value | Count | Frequency (%) |
| 8 | 178852 | |
| 7 | 511 | 0.3% |
| 6 | 600 | 0.3% |
| 5 | 91 | < 0.1% |
| 4 | 2892 | 1.5% |
| 3 | 14664 | 7.4% |
| 2 | 950 | 0.5% |
| 1 | 350 | 0.2% |
Permit Type Definition
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.1 MiB |
| otc alterations permit | |
|---|---|
| additions alterations or repairs | 14663 |
| sign - erect | 2892 |
| new construction wood frame | 950 |
| demolitions | 600 |
| Other values (8) | 969 |
Length
| Max length | 35 |
|---|---|
| Median length | 22 |
| Mean length | 22.572978 |
| Min length | 11 |
Characters and Unicode
| Total characters | 4489991 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | otc alterations permit |
|---|---|
| 2nd row | otc alterations permit |
| 3rd row | otc alterations permit |
| 4th row | otc alterations permit |
| 5th row | otc alterations permit |
Common Values
| Value | Count | Frequency (%) |
| otc alterations permit | 178836 | |
| additions alterations or repairs | 14663 | 7.4% |
| sign - erect | 2892 | 1.5% |
| new construction wood frame | 950 | 0.5% |
| demolitions | 600 | 0.3% |
| wall or painted sign | 511 | 0.3% |
| new construction | 347 | 0.2% |
| grade or quarry or fill or excavate | 91 | < 0.1% |
| otc alterations permit | 8 | < 0.1% |
| otc alterations permit # | 8 | < 0.1% |
| Other values (3) | 4 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| alterations | 193516 | |
| otc | 178852 | |
| permit | 178852 | |
| or | 15448 | 2.5% |
| additions | 14664 | 2.4% |
| repairs | 14664 | 2.4% |
| sign | 3403 | 0.6% |
| 2902 | 0.5% | |
| erect | 2892 | 0.5% |
| construction | 1300 | 0.2% |
| Other values (10) | 5186 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
| Distinct | 1291 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2012-03-28 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Block
Text
| Distinct | 4896 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.0363933 |
| Min length | 3 |
Characters and Unicode
| Total characters | 802879 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 124 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 0215 |
|---|---|
| 2nd row | 1810 |
| 3rd row | 5700 |
| 4th row | 0661 |
| 5th row | 3642 |
| Value | Count | Frequency (%) |
| 3708 | 1195 | 0.6% |
| 3735 | 750 | 0.4% |
| 7331 | 680 | 0.3% |
| 0289 | 640 | 0.3% |
| 3709 | 584 | 0.3% |
| 3717 | 578 | 0.3% |
| 3707 | 576 | 0.3% |
| 3721 | 567 | 0.3% |
| 3706 | 561 | 0.3% |
| 0259 | 554 | 0.3% |
| Other values (4886) | 192225 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 124327 | |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | 6.1% |
| Other values (9) | 7231 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 802879 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124327 | |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | 6.1% |
| Other values (9) | 7231 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 802879 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124327 | |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | 6.1% |
| Other values (9) | 7231 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 802879 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124327 | |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | 6.1% |
| Other values (9) | 7231 | 0.9% |
Lot
Text
| Distinct | 1055 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.4 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0798753 |
| Min length | 3 |
Characters and Unicode
| Total characters | 612618 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 180 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 001 |
|---|---|
| 2nd row | 017A |
| 3rd row | 027 |
| 4th row | 005 |
| 5th row | 051A |
| Value | Count | Frequency (%) |
| 001 | 10116 | 5.1% |
| 007 | 5317 | 2.7% |
| 002 | 5184 | 2.6% |
| 003 | 5042 | 2.5% |
| 006 | 4835 | 2.4% |
| 008 | 4773 | 2.4% |
| 009 | 4590 | 2.3% |
| 005 | 4549 | 2.3% |
| 004 | 4384 | 2.2% |
| 011 | 4238 | 2.1% |
| Other values (1045) | 145882 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 266819 | |
| 1 | 80415 | 13.1% |
| 2 | 59437 | 9.7% |
| 3 | 43028 | 7.0% |
| 4 | 33218 | 5.4% |
| 5 | 26863 | 4.4% |
| 6 | 25008 | 4.1% |
| 7 | 22210 | 3.6% |
| 8 | 20304 | 3.3% |
| 9 | 19441 | 3.2% |
| Other values (26) | 15875 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 612618 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 266819 | |
| 1 | 80415 | 13.1% |
| 2 | 59437 | 9.7% |
| 3 | 43028 | 7.0% |
| 4 | 33218 | 5.4% |
| 5 | 26863 | 4.4% |
| 6 | 25008 | 4.1% |
| 7 | 22210 | 3.6% |
| 8 | 20304 | 3.3% |
| 9 | 19441 | 3.2% |
| Other values (26) | 15875 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 612618 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 266819 | |
| 1 | 80415 | 13.1% |
| 2 | 59437 | 9.7% |
| 3 | 43028 | 7.0% |
| 4 | 33218 | 5.4% |
| 5 | 26863 | 4.4% |
| 6 | 25008 | 4.1% |
| 7 | 22210 | 3.6% |
| 8 | 20304 | 3.3% |
| 9 | 19441 | 3.2% |
| Other values (26) | 15875 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 612618 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 266819 | |
| 1 | 80415 | 13.1% |
| 2 | 59437 | 9.7% |
| 3 | 43028 | 7.0% |
| 4 | 33218 | 5.4% |
| 5 | 26863 | 4.4% |
| 6 | 25008 | 4.1% |
| 7 | 22210 | 3.6% |
| 8 | 20304 | 3.3% |
| 9 | 19441 | 3.2% |
| Other values (26) | 15875 | 2.6% |
Street Number
Real number (ℝ)
| Distinct | 5099 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1121.7155 |
| Minimum | 0 |
|---|---|
| Maximum | 8400 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 235 |
| median | 710 |
| Q3 | 1700 |
| 95-th percentile | 3481 |
| Maximum | 8400 |
| Range | 8400 |
| Interquartile range (IQR) | 1465 |
Descriptive statistics
| Standard deviation | 1135.7985 |
|---|---|
| Coefficient of variation (CV) | 1.0125548 |
| Kurtosis | 2.1350541 |
| Mean | 1121.7155 |
| Median Absolute Deviation (MAD) | 580 |
| Skewness | 1.4269693 |
| Sum | 2.2312044 × 108 |
| Variance | 1290038.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2398 | 1.2% |
| 101 | 1153 | 0.6% |
| 100 | 1143 | 0.6% |
| 50 | 1103 | 0.6% |
| 201 | 1026 | 0.5% |
| 555 | 994 | 0.5% |
| 2 | 814 | 0.4% |
| 55 | 734 | 0.4% |
| 350 | 705 | 0.4% |
| 150 | 672 | 0.3% |
| Other values (5089) | 188168 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 2398 | |
| 2 | 814 | 0.4% |
| 3 | 309 | 0.2% |
| 4 | 255 | 0.1% |
| 5 | 194 | 0.1% |
| 6 | 113 | 0.1% |
| 7 | 132 | 0.1% |
| 8 | 281 | 0.1% |
| 9 | 128 | 0.1% |
| Value | Count | Frequency (%) |
| 8400 | 3 | |
| 8331 | 1 | < 0.1% |
| 8325 | 5 | |
| 8320 | 1 | < 0.1% |
| 8300 | 1 | < 0.1% |
| 8245 | 1 | < 0.1% |
| 8231 | 1 | < 0.1% |
| 8228 | 1 | < 0.1% |
| 8222 | 7 | |
| 8219 | 1 | < 0.1% |
Street Number Suffix
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 196694 |
| Missing (%) | 98.9% |
| Memory size | 10.6 MiB |
| A | |
|---|---|
| B | |
| V | |
| C | 56 |
| E | 28 |
| Other values (13) | 112 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2216 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | B |
|---|---|
| 2nd row | A |
| 3rd row | V |
| 4th row | A |
| 5th row | V |
Common Values
| Value | Count | Frequency (%) |
| A | 1501 | 0.8% |
| B | 291 | 0.1% |
| V | 228 | 0.1% |
| C | 56 | < 0.1% |
| E | 28 | < 0.1% |
| F | 24 | < 0.1% |
| G | 12 | < 0.1% |
| D | 11 | < 0.1% |
| H | 11 | < 0.1% |
| K | 11 | < 0.1% |
| Other values (8) | 43 | < 0.1% |
| (Missing) | 196694 |
Length
| Value | Count | Frequency (%) |
| a | 1501 | |
| b | 291 | 13.1% |
| v | 228 | 10.3% |
| c | 56 | 2.5% |
| e | 28 | 1.3% |
| f | 24 | 1.1% |
| g | 12 | 0.5% |
| h | 11 | 0.5% |
| k | 11 | 0.5% |
| d | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Street Name
Text
| Distinct | 1714 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 22 |
| Mean length | 6.5098185 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1294868 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 117 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | jOnEs |
|---|---|
| 2nd row | 43rD |
| 3rd row | pReNtIsS |
| 4th row | bUsH |
| 5th row | cApP |
| Value | Count | Frequency (%) |
| market | 5443 | 2.6% |
| california | 4587 | 2.2% |
| mission | 4324 | 2.0% |
| montgomery | 2933 | 1.4% |
| geary | 1966 | 0.9% |
| 20th | 1859 | 0.9% |
| 03rd | 1819 | 0.9% |
| folsom | 1776 | 0.8% |
| van | 1698 | 0.8% |
| pine | 1678 | 0.8% |
| Other values (1705) | 184679 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Street Suffix
Categorical
IMBALANCE  MISSING 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2768 |
| Missing (%) | 1.4% |
| Memory size | 11.2 MiB |
| St | |
|---|---|
| Av | |
| Bl | 3555 |
| Wy | 3540 |
| Dr | 3267 |
| Other values (16) | 4193 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 392284 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | St |
|---|---|
| 2nd row | Av |
| 3rd row | St |
| 4th row | St |
| 5th row | St |
Common Values
| Value | Count | Frequency (%) |
| St | 138365 | |
| Av | 43222 | 21.7% |
| Bl | 3555 | 1.8% |
| Wy | 3540 | 1.8% |
| Dr | 3267 | 1.6% |
| Tr | 1466 | 0.7% |
| Ct | 667 | 0.3% |
| Pl | 538 | 0.3% |
| Rd | 389 | 0.2% |
| Ln | 354 | 0.2% |
| Other values (11) | 779 | 0.4% |
| (Missing) | 2768 | 1.4% |
Length
| Value | Count | Frequency (%) |
| st | 138365 | |
| av | 43222 | 22.0% |
| bl | 3555 | 1.8% |
| wy | 3540 | 1.8% |
| dr | 3267 | 1.7% |
| tr | 1466 | 0.7% |
| ct | 667 | 0.3% |
| pl | 538 | 0.3% |
| rd | 389 | 0.2% |
| ln | 354 | 0.2% |
| Other values (11) | 779 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Unit
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 660 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 169430 |
| Missing (%) | 85.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.514518 |
| Minimum | 0 |
|---|---|
| Maximum | 6004 |
| Zeros | 21411 |
| Zeros (%) | 10.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 446.1 |
| Maximum | 6004 |
| Range | 6004 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 326.9761 |
|---|---|
| Coefficient of variation (CV) | 4.1645304 |
| Kurtosis | 92.15637 |
| Mean | 78.514518 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.1334162 |
| Sum | 2314608 |
| Variance | 106913.37 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 21411 | 10.8% |
| 1 | 1312 | 0.7% |
| 2 | 549 | 0.3% |
| 3 | 448 | 0.2% |
| 101 | 365 | 0.2% |
| 4 | 288 | 0.1% |
| 6 | 214 | 0.1% |
| 5 | 211 | 0.1% |
| 201 | 210 | 0.1% |
| 8 | 104 | 0.1% |
| Other values (650) | 4368 | 2.2% |
| (Missing) | 169430 |
| Value | Count | Frequency (%) |
| 0 | 21411 | |
| 1 | 1312 | 0.7% |
| 2 | 549 | 0.3% |
| 3 | 448 | 0.2% |
| 4 | 288 | 0.1% |
| 5 | 211 | 0.1% |
| 6 | 214 | 0.1% |
| 7 | 103 | 0.1% |
| 8 | 104 | 0.1% |
| 9 | 69 | < 0.1% |
| Value | Count | Frequency (%) |
| 6004 | 1 | < 0.1% |
| 6003 | 3 | |
| 5903 | 1 | < 0.1% |
| 5604 | 1 | < 0.1% |
| 5602 | 1 | < 0.1% |
| 5413 | 1 | < 0.1% |
| 5412 | 1 | < 0.1% |
| 5313 | 1 | < 0.1% |
| 5312 | 1 | < 0.1% |
| 5306 | 1 | < 0.1% |
Unit Suffix
Text
MISSING 
| Distinct | 164 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 196949 |
| Missing (%) | 99.0% |
| Memory size | 6.1 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 1 |
| Mean length | 2.6017338 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5102 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 60 ? |
|---|---|
| Unique (%) | 3.1% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | RESID'L |
| 4th row | D |
| 5th row | E |
| Value | Count | Frequency (%) |
| a | 354 | |
| c | 229 | 10.7% |
| b | 199 | 9.3% |
| d | 137 | 6.4% |
| e | 93 | 4.3% |
| bldg | 93 | 4.3% |
| hoa | 85 | 4.0% |
| f | 78 | 3.6% |
| comml | 51 | 2.4% |
| front | 48 | 2.2% |
| Other values (135) | 782 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 545 | 10.7% |
| C | 409 | 8.0% |
| E | 321 | 6.3% |
| B | 315 | 6.2% |
| R | 311 | 6.1% |
| D | 295 | 5.8% |
| O | 264 | 5.2% |
| L | 261 | 5.1% |
| F | 208 | 4.1% |
| 188 | 3.7% | |
| Other values (36) | 1985 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5102 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 545 | 10.7% |
| C | 409 | 8.0% |
| E | 321 | 6.3% |
| B | 315 | 6.2% |
| R | 311 | 6.1% |
| D | 295 | 5.8% |
| O | 264 | 5.2% |
| L | 261 | 5.1% |
| F | 208 | 4.1% |
| 188 | 3.7% | |
| Other values (36) | 1985 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5102 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 545 | 10.7% |
| C | 409 | 8.0% |
| E | 321 | 6.3% |
| B | 315 | 6.2% |
| R | 311 | 6.1% |
| D | 295 | 5.8% |
| O | 264 | 5.2% |
| L | 261 | 5.1% |
| F | 208 | 4.1% |
| 188 | 3.7% | |
| Other values (36) | 1985 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5102 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 545 | 10.7% |
| C | 409 | 8.0% |
| E | 321 | 6.3% |
| B | 315 | 6.2% |
| R | 311 | 6.1% |
| D | 295 | 5.8% |
| O | 264 | 5.2% |
| L | 261 | 5.1% |
| F | 208 | 4.1% |
| 188 | 3.7% | |
| Other values (36) | 1985 |
Description
Text
| Distinct | 134272 |
|---|---|
| Distinct (%) | 67.6% |
| Missing | 290 |
| Missing (%) | 0.1% |
| Memory size | 30.0 MiB |
Length
| Max length | 300 |
|---|---|
| Median length | 243 |
| Mean length | 101.45318 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20150631 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 122032 ? |
|---|---|
| Unique (%) | 61.4% |
Sample
| 1st row | street space |
|---|---|
| 2nd row | remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting. |
| 3rd row | replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window |
| 4th row | two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units. |
| 5th row | reroofing |
| Value | Count | Frequency (%) |
| 94921 | 3.0% | |
| to | 93338 | 2.9% |
| and | 68894 | 2.2% |
| new | 61786 | 1.9% |
| of | 54700 | 1.7% |
| street | 44273 | 1.4% |
| space | 41100 | 1.3% |
| replace | 36545 | 1.1% |
| in | 36109 | 1.1% |
| for | 35061 | 1.1% |
| Other values (109535) | 2636742 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Current Status
Categorical
IMBALANCE 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.1 MiB |
| complete | |
|---|---|
| issued | |
| filed | |
| withdrawn | 1754 |
| cancelled | 1536 |
| Other values (9) | 2931 |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 6.9923282 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1390844 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | issued |
|---|---|
| 2nd row | complete |
| 3rd row | issued |
| 4th row | complete |
| 5th row | issued |
Common Values
| Value | Count | Frequency (%) |
| complete | 97081 | |
| issued | 83563 | |
| filed | 12045 | 6.1% |
| withdrawn | 1754 | 0.9% |
| cancelled | 1536 | 0.8% |
| expired | 1370 | 0.7% |
| approved | 733 | 0.4% |
| reinstated | 563 | 0.3% |
| suspend | 193 | 0.1% |
| revoked | 50 | < 0.1% |
| Other values (4) | 22 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| complete | 97081 | |
| issued | 83563 | |
| filed | 12045 | 6.1% |
| withdrawn | 1754 | 0.9% |
| cancelled | 1536 | 0.8% |
| expired | 1370 | 0.7% |
| approved | 733 | 0.4% |
| reinstated | 563 | 0.3% |
| suspend | 193 | 0.1% |
| revoked | 50 | < 0.1% |
| Other values (4) | 22 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
| Distinct | 1307 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2019-03-02 00:00:00 |
Filed Date
Date
| Distinct | 1288 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Issued Date
Date
MISSING 
| Distinct | 1289 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 14942 |
| Missing (%) | 7.5% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Completed Date
Date
MISSING 
| Distinct | 1300 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 101715 |
| Missing (%) | 51.1% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-04 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
First Construction Document Date
Date
MISSING 
| Distinct | 1288 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 14948 |
| Missing (%) | 7.5% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Structural Notification
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 191988 |
| Missing (%) | 96.5% |
| Memory size | 388.6 KiB |
| True | 6922 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 6922 | 3.5% |
| (Missing) | 191988 |
Number of Existing Stories
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 42788 |
| Missing (%) | 21.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.7057077 |
| Minimum | 0 |
|---|---|
| Maximum | 78 |
| Zeros | 442 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 26 |
| Maximum | 78 |
| Range | 78 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 8.6133098 |
|---|---|
| Coefficient of variation (CV) | 1.5095953 |
| Kurtosis | 11.309873 |
| Mean | 5.7057077 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.2978123 |
| Sum | 890786.5 |
| Variance | 74.189106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 52770 | |
| 3 | 45741 | |
| 4 | 16055 | 8.1% |
| 1 | 8793 | 4.4% |
| 5 | 3767 | 1.9% |
| 6 | 3696 | 1.9% |
| 7 | 2359 | 1.2% |
| 8 | 1732 | 0.9% |
| 9 | 1264 | 0.6% |
| 10 | 1129 | 0.6% |
| Other values (54) | 18816 | 9.5% |
| (Missing) | 42788 |
| Value | Count | Frequency (%) |
| 0 | 442 | 0.2% |
| 1 | 8793 | 4.4% |
| 1.5 | 1 | < 0.1% |
| 2 | 52770 | |
| 2.5 | 2 | < 0.1% |
| 3 | 45741 | |
| 4 | 16055 | 8.1% |
| 5 | 3767 | 1.9% |
| 6 | 3696 | 1.9% |
| 7 | 2359 | 1.2% |
| Value | Count | Frequency (%) |
| 78 | 1 | < 0.1% |
| 63 | 99 | |
| 62 | 2 | < 0.1% |
| 61 | 24 | < 0.1% |
| 60 | 18 | < 0.1% |
| 58 | 93 | |
| 56 | 4 | < 0.1% |
| 55 | 14 | < 0.1% |
| 54 | 7 | < 0.1% |
| 53 | 12 | < 0.1% |
Number of Proposed Stories
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 42871 |
| Missing (%) | 21.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.7449644 |
| Minimum | 0 |
|---|---|
| Maximum | 78 |
| Zeros | 174 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 26 |
| Maximum | 78 |
| Range | 78 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 8.6131126 |
|---|---|
| Coefficient of variation (CV) | 1.4992456 |
| Kurtosis | 11.46678 |
| Mean | 5.7449644 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.3179006 |
| Sum | 896438.5 |
| Variance | 74.185708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 50994 | |
| 3 | 46803 | |
| 4 | 17594 | 8.8% |
| 1 | 7893 | 4.0% |
| 5 | 4044 | 2.0% |
| 6 | 3792 | 1.9% |
| 7 | 2318 | 1.2% |
| 8 | 1703 | 0.9% |
| 9 | 1334 | 0.7% |
| 11 | 1120 | 0.6% |
| Other values (54) | 18444 | 9.3% |
| (Missing) | 42871 |
| Value | Count | Frequency (%) |
| 0 | 174 | 0.1% |
| 1 | 7893 | 4.0% |
| 1.5 | 1 | < 0.1% |
| 2 | 50994 | |
| 2.5 | 2 | < 0.1% |
| 3 | 46803 | |
| 4 | 17594 | 8.8% |
| 5 | 4044 | 2.0% |
| 6 | 3792 | 1.9% |
| 7 | 2318 | 1.2% |
| Value | Count | Frequency (%) |
| 78 | 1 | < 0.1% |
| 63 | 105 | |
| 62 | 4 | < 0.1% |
| 61 | 24 | < 0.1% |
| 60 | 19 | < 0.1% |
| 58 | 90 | |
| 56 | 11 | < 0.1% |
| 55 | 23 | < 0.1% |
| 54 | 14 | < 0.1% |
| 53 | 12 | < 0.1% |
Voluntary Soft-Story Retrofit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 198875 |
| Missing (%) | > 99.9% |
| Memory size | 388.6 KiB |
| True | 35 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 35 | < 0.1% |
| (Missing) | 198875 |
Fire Only Permit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 180082 |
| Missing (%) | 90.5% |
| Memory size | 388.6 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 18828 | 9.5% |
| (Missing) | 180082 |
MISSING 
| Distinct | 2232 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 51884 |
| Missing (%) | 26.1% |
| Memory size | 1.5 MiB |
| Minimum | 2013-07-15 00:00:00 |
|---|---|
| Maximum | 2024-02-21 00:00:00 |
Estimated Cost
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 11395 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 38068 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169009.86 |
| Minimum | 1 |
|---|---|
| Maximum | 5.3795865 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3300 |
| median | 11000 |
| Q3 | 35000 |
| 95-th percentile | 275000 |
| Maximum | 5.3795865 × 108 |
| Range | 5.3795864 × 108 |
| Interquartile range (IQR) | 31700 |
Descriptive statistics
| Standard deviation | 3630376.9 |
|---|---|
| Coefficient of variation (CV) | 21.480267 |
| Kurtosis | 8911.3386 |
| Mean | 169009.86 |
| Median Absolute Deviation (MAD) | 10000 |
| Skewness | 80.264355 |
| Sum | 2.7183884 × 1010 |
| Variance | 1.3179636 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 17014 | 8.6% |
| 10000 | 6695 | 3.4% |
| 5000 | 6437 | 3.2% |
| 20000 | 5702 | 2.9% |
| 15000 | 4779 | 2.4% |
| 30000 | 3939 | 2.0% |
| 25000 | 3599 | 1.8% |
| 3000 | 3569 | 1.8% |
| 50000 | 3345 | 1.7% |
| 2000 | 3203 | 1.6% |
| Other values (11385) | 102560 | |
| (Missing) | 38068 | 19.1% |
| Value | Count | Frequency (%) |
| 1 | 17014 | |
| 2 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 3 | < 0.1% |
| 10 | 11 | < 0.1% |
| 20 | 5 | < 0.1% |
| 25 | 7 | < 0.1% |
| 30 | 3 | < 0.1% |
| 35 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 537958646 | 1 | |
| 520000000 | 1 | |
| 400000000 | 2 | |
| 340000000 | 1 | |
| 272000000 | 1 | |
| 270000000 | 1 | |
| 239000000 | 1 | |
| 210000000 | 1 | |
| 175000000 | 1 | |
| 167000000 | 2 |
Revised Cost
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED  ZEROS 
| Distinct | 12629 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 6066 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 132901.75 |
| Minimum | 0 |
|---|---|
| Maximum | 7.805 × 108 |
| Zeros | 8514 |
| Zeros (%) | 4.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 7000 |
| Q3 | 28715 |
| 95-th percentile | 227340 |
| Maximum | 7.805 × 108 |
| Range | 7.805 × 108 |
| Interquartile range (IQR) | 28714 |
Descriptive statistics
| Standard deviation | 3584878.7 |
|---|---|
| Coefficient of variation (CV) | 26.973901 |
| Kurtosis | 17049.467 |
| Mean | 132901.75 |
| Median Absolute Deviation (MAD) | 6999 |
| Skewness | 108.7016 |
| Sum | 2.5629306 × 1010 |
| Variance | 1.2851355 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 47229 | |
| 0 | 8514 | 4.3% |
| 10000 | 5474 | 2.8% |
| 5000 | 5453 | 2.7% |
| 20000 | 4696 | 2.4% |
| 15000 | 4001 | 2.0% |
| 30000 | 3291 | 1.7% |
| 25000 | 3135 | 1.6% |
| 3000 | 3067 | 1.5% |
| 2000 | 2955 | 1.5% |
| Other values (12619) | 105029 | |
| (Missing) | 6066 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 8514 | 4.3% |
| 0.01 | 1 | < 0.1% |
| 1 | 47229 | |
| 1.2 | 1 | < 0.1% |
| 2 | 4 | < 0.1% |
| 5 | 3 | < 0.1% |
| 10 | 11 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 780500000 | 1 | < 0.1% |
| 520000000 | 1 | < 0.1% |
| 400000000 | 2 | |
| 336200000 | 1 | < 0.1% |
| 270000000 | 1 | < 0.1% |
| 266061486 | 1 | < 0.1% |
| 239000000 | 1 | < 0.1% |
| 210000000 | 1 | < 0.1% |
| 207680000 | 1 | < 0.1% |
| 200000000 | 4 |
Existing Use
Text
MISSING 
| Distinct | 93 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 41117 |
| Missing (%) | 20.7% |
| Memory size | 11.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 13.170286 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2078179 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 family dwelling |
|---|---|
| 2nd row | 1 family dwelling |
| 3rd row | 2 family dwelling |
| 4th row | apartments |
| 5th row | apartments |
| Value | Count | Frequency (%) |
| family | 67756 | |
| dwelling | 67756 | |
| 1 | 46768 | |
| apartments | 40800 | |
| office | 24617 | 7.8% |
| 2 | 20988 | 6.6% |
| sales | 7032 | 2.2% |
| retail | 6910 | 2.2% |
| hndlng | 4886 | 1.5% |
| food/beverage | 4886 | 1.5% |
| Other values (144) | 24040 | 7.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Existing Units
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 348 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 51543 |
| Missing (%) | 25.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.666006 |
| Minimum | 0 |
|---|---|
| Maximum | 1907 |
| Zeros | 29135 |
| Zeros (%) | 14.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 64 |
| Maximum | 1907 |
| Range | 1907 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 74.47512 |
|---|---|
| Coefficient of variation (CV) | 4.7539316 |
| Kurtosis | 238.3122 |
| Mean | 15.666006 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.867436 |
| Sum | 2308652.3 |
| Variance | 5546.5435 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 47347 | |
| 0 | 29135 | |
| 2 | 21805 | |
| 3 | 8616 | 4.3% |
| 6 | 6066 | 3.0% |
| 4 | 5364 | 2.7% |
| 12 | 2535 | 1.3% |
| 5 | 2347 | 1.2% |
| 8 | 1728 | 0.9% |
| 9 | 1188 | 0.6% |
| Other values (338) | 21236 | |
| (Missing) | 51543 |
| Value | Count | Frequency (%) |
| 0 | 29135 | |
| 0.3 | 1 | < 0.1% |
| 1 | 47347 | |
| 2 | 21805 | |
| 3 | 8616 | 4.3% |
| 4 | 5364 | 2.7% |
| 5 | 2347 | 1.2% |
| 6 | 6066 | 3.0% |
| 7 | 1172 | 0.6% |
| 8 | 1728 | 0.9% |
| Value | Count | Frequency (%) |
| 1907 | 44 | |
| 1732 | 8 | < 0.1% |
| 1500 | 51 | |
| 1499 | 1 | < 0.1% |
| 1186 | 51 | |
| 1010 | 2 | < 0.1% |
| 1005 | 21 | |
| 1004 | 2 | < 0.1% |
| 1000 | 1 | < 0.1% |
| 948 | 1 | < 0.1% |
Proposed Use
Text
MISSING 
| Distinct | 94 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 42441 |
| Missing (%) | 21.3% |
| Memory size | 11.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 13.208827 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2066772 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 family dwelling |
|---|---|
| 2nd row | 1 family dwelling |
| 3rd row | 2 family dwelling |
| 4th row | apartments |
| 5th row | apartments |
| Value | Count | Frequency (%) |
| family | 68410 | |
| dwelling | 68410 | |
| 1 | 46348 | |
| apartments | 43035 | |
| office | 23963 | 7.7% |
| 2 | 22062 | 7.0% |
| sales | 5193 | 1.7% |
| retail | 5079 | 1.6% |
| food/beverage | 5053 | 1.6% |
| hndlng | 5053 | 1.6% |
| Other values (146) | 20614 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Proposed Units
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 368 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 50915 |
| Missing (%) | 25.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.510882 |
| Minimum | 0 |
|---|---|
| Maximum | 1911 |
| Zeros | 26885 |
| Zeros (%) | 13.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 70 |
| Maximum | 1911 |
| Range | 1911 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 75.218997 |
|---|---|
| Coefficient of variation (CV) | 4.5557225 |
| Kurtosis | 223.71262 |
| Mean | 16.510882 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.330487 |
| Sum | 2443528 |
| Variance | 5657.8975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 46914 | |
| 0 | 26885 | |
| 2 | 22892 | |
| 3 | 9347 | 4.7% |
| 6 | 5872 | 3.0% |
| 4 | 5504 | 2.8% |
| 12 | 2474 | 1.2% |
| 5 | 2400 | 1.2% |
| 8 | 1800 | 0.9% |
| 7 | 1336 | 0.7% |
| Other values (358) | 22571 | |
| (Missing) | 50915 |
| Value | Count | Frequency (%) |
| 0 | 26885 | |
| 1 | 46914 | |
| 2 | 22892 | |
| 3 | 9347 | 4.7% |
| 4 | 5504 | 2.8% |
| 5 | 2400 | 1.2% |
| 6 | 5872 | 3.0% |
| 7 | 1336 | 0.7% |
| 8 | 1800 | 0.9% |
| 9 | 1270 | 0.6% |
| Value | Count | Frequency (%) |
| 1911 | 1 | < 0.1% |
| 1907 | 43 | |
| 1732 | 8 | < 0.1% |
| 1500 | 48 | |
| 1499 | 1 | < 0.1% |
| 1199 | 1 | < 0.1% |
| 1186 | 47 | |
| 1014 | 4 | < 0.1% |
| 1010 | 2 | < 0.1% |
| 1005 | 17 | < 0.1% |
Plansets
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED  ZEROS 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 37311 |
| Missing (%) | 18.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.274649 |
| Minimum | 0 |
|---|---|
| Maximum | 9000 |
| Zeros | 63247 |
| Zeros (%) | 31.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 9000 |
| Range | 9000 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 22.406792 |
|---|---|
| Coefficient of variation (CV) | 17.578794 |
| Kurtosis | 160982 |
| Mean | 1.274649 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 400.84207 |
| Sum | 205982 |
| Variance | 502.06432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 98093 | |
| 0 | 63247 | |
| 3 | 250 | 0.1% |
| 4 | 3 | < 0.1% |
| 6 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 9000 | 1 | < 0.1% |
| (Missing) | 37311 | 18.8% |
| Value | Count | Frequency (%) |
| 0 | 63247 | |
| 1 | 2 | < 0.1% |
| 2 | 98093 | |
| 3 | 250 | 0.1% |
| 4 | 3 | < 0.1% |
| 6 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 9000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9000 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 3 | < 0.1% |
| 3 | 250 | 0.1% |
| 2 | 98093 | |
| 1 | 2 | < 0.1% |
| 0 | 63247 |
TIDF Compliance
Text
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 198908 |
| Missing (%) | > 99.9% |
| Memory size | 6.1 MiB |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | Y |
| Value | Count | Frequency (%) |
| p | 1 | |
| y | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Existing Construction Type
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43369 |
| Missing (%) | 21.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.7156312 |
| Minimum | -99999 |
|---|---|
| Maximum | 99999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -99999 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 99999 |
| Range | 199998 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 566.96662 |
|---|---|
| Coefficient of variation (CV) | 120.23133 |
| Kurtosis | 31105.634 |
| Mean | 4.7156312 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 35.250938 |
| Sum | 733474 |
| Variance | 321451.15 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 113350 | |
| 1 | 28073 | 14.1% |
| 3 | 9664 | 4.9% |
| 2 | 4068 | 2.0% |
| 4 | 381 | 0.2% |
| 99999 | 3 | < 0.1% |
| -99999 | 2 | < 0.1% |
| (Missing) | 43369 | 21.8% |
| Value | Count | Frequency (%) |
| -99999 | 2 | < 0.1% |
| 1 | 28073 | 14.1% |
| 2 | 4068 | 2.0% |
| 3 | 9664 | 4.9% |
| 4 | 381 | 0.2% |
| 5 | 113350 | |
| 99999 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99999 | 3 | < 0.1% |
| 5 | 113350 | |
| 4 | 381 | 0.2% |
| 3 | 9664 | 4.9% |
| 2 | 4068 | 2.0% |
| 1 | 28073 | 14.1% |
| -99999 | 2 | < 0.1% |
Existing Construction Type Description
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43370 |
| Missing (%) | 21.8% |
| Memory size | 12.8 MiB |
| wood frame (5) | |
|---|---|
| constr type 1 | |
| constr type 3 | 9663 |
| constr type 2 | 4068 |
| constr type 4 | 381 |
| Other values (3) | 6 |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 13.728854 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2135386 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | wood frame (5) |
|---|---|
| 2nd row | wood frame (5) |
| 3rd row | wood frame (5) |
| 4th row | wood frame (5) |
| 5th row | wood frame (5) |
Common Values
| Value | Count | Frequency (%) |
| wood frame (5) | 113350 | |
| constr type 1 | 28072 | 14.1% |
| constr type 3 | 9663 | 4.9% |
| constr type 2 | 4068 | 2.0% |
| constr type 4 | 381 | 0.2% |
| wood frame (5) | 4 | < 0.1% |
| constr type 1 | 1 | < 0.1% |
| constr type 3 | 1 | < 0.1% |
| (Missing) | 43370 | 21.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wood | 113354 | |
| frame | 113354 | |
| 5 | 113354 | |
| constr | 42186 | 9.0% |
| type | 42186 | 9.0% |
| 1 | 28073 | 6.0% |
| 3 | 9664 | 2.1% |
| 2 | 4068 | 0.9% |
| 4 | 381 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Proposed Construction Type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43165 |
| Missing (%) | 21.7% |
| Memory size | 11.2 MiB |
| 5.0 | |
|---|---|
| 1.0 | |
| 3.0 | 9361 |
| 2.0 | 3778 |
| 4.0 | 377 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 467235 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5.0 |
|---|---|
| 2nd row | 5.0 |
| 3rd row | 5.0 |
| 4th row | 5.0 |
| 5th row | 5.0 |
Common Values
| Value | Count | Frequency (%) |
| 5.0 | 114386 | |
| 1.0 | 27843 | 14.0% |
| 3.0 | 9361 | 4.7% |
| 2.0 | 3778 | 1.9% |
| 4.0 | 377 | 0.2% |
| (Missing) | 43165 | 21.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5.0 | 114386 | |
| 1.0 | 27843 | 17.9% |
| 3.0 | 9361 | 6.0% |
| 2.0 | 3778 | 2.4% |
| 4.0 | 377 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Proposed Construction Type Description
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43165 |
| Missing (%) | 21.7% |
| Memory size | 12.8 MiB |
| wood frame (5) | |
|---|---|
| constr type 1 | |
| constr type 3 | 9361 |
| constr type 2 | 3778 |
| constr type 4 | 377 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.734444 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2139071 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | wood frame (5) |
|---|---|
| 2nd row | wood frame (5) |
| 3rd row | wood frame (5) |
| 4th row | wood frame (5) |
| 5th row | wood frame (5) |
Common Values
| Value | Count | Frequency (%) |
| wood frame (5) | 114386 | |
| constr type 1 | 27843 | 14.0% |
| constr type 3 | 9361 | 4.7% |
| constr type 2 | 3778 | 1.9% |
| constr type 4 | 377 | 0.2% |
| (Missing) | 43165 | 21.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wood | 114386 | |
| frame | 114386 | |
| 5 | 114386 | |
| constr | 41359 | 8.9% |
| type | 41359 | 8.9% |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Site Permit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 193550 |
| Missing (%) | 97.3% |
| Memory size | 388.6 KiB |
| True | 5360 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 5360 | 2.7% |
| (Missing) | 193550 |
Supervisor District
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 1719 |
|---|---|
| Missing (%) | 0.9% |
| Memory size | 7.4 MiB |
Neighborhoods - Analysis Boundaries
Categorical
HIGH CORRELATION 
| Distinct | 41 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1725 |
| Missing (%) | 0.9% |
| Memory size | 13.6 MiB |
| Financial District/South Beach | |
|---|---|
| Mission | |
| Sunset/Parkside | 10207 |
| West of Twin Peaks | 8740 |
| Castro/Upper Market | 8527 |
| Other values (36) |
Length
| Max length | 30 |
|---|---|
| Median length | 18 |
| Mean length | 14.780977 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2914587 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nob Hill |
|---|---|
| 2nd row | Sunset/Parkside |
| 3rd row | Bernal Heights |
| 4th row | Pacific Heights |
| 5th row | Mission |
Common Values
| Value | Count | Frequency (%) |
| Financial District/South Beach | 21816 | 11.0% |
| Mission | 14682 | 7.4% |
| Sunset/Parkside | 10207 | 5.1% |
| West of Twin Peaks | 8740 | 4.4% |
| Castro/Upper Market | 8527 | 4.3% |
| Pacific Heights | 8508 | 4.3% |
| Marina | 8244 | 4.1% |
| Outer Richmond | 7855 | 3.9% |
| Noe Valley | 7844 | 3.9% |
| South of Market | 7573 | 3.8% |
| Other values (31) | 93189 |
Length
| Value | Count | Frequency (%) |
| beach | 25870 | 6.5% |
| financial | 21816 | 5.5% |
| district/south | 21816 | 5.5% |
| mission | 19211 | 4.9% |
| heights | 18661 | 4.7% |
| of | 16313 | 4.1% |
| market | 16100 | 4.1% |
| hill | 15798 | 4.0% |
| valley | 14233 | 3.6% |
| richmond | 12313 | 3.1% |
| Other values (46) | 212950 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Zipcode
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1716 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94115.501 |
| Minimum | 94102 |
|---|---|
| Maximum | 94158 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 94102 |
|---|---|
| 5-th percentile | 94103 |
| Q1 | 94109 |
| median | 94114 |
| Q3 | 94122 |
| 95-th percentile | 94133 |
| Maximum | 94158 |
| Range | 56 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 9.2701045 |
|---|---|
| Coefficient of variation (CV) | 9.8497107 × 10-5 |
| Kurtosis | 1.2263383 |
| Mean | 94115.501 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.85171252 |
| Sum | 1.8559012 × 1010 |
| Variance | 85.934838 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 94110 | 17838 | 9.0% |
| 94114 | 13404 | 6.7% |
| 94117 | 11781 | 5.9% |
| 94109 | 11348 | 5.7% |
| 94103 | 10988 | 5.5% |
| 94115 | 10095 | 5.1% |
| 94118 | 9813 | 4.9% |
| 94123 | 9515 | 4.8% |
| 94122 | 8886 | 4.5% |
| 94105 | 8628 | 4.3% |
| Other values (17) | 84898 |
| Value | Count | Frequency (%) |
| 94102 | 7164 | |
| 94103 | 10988 | |
| 94104 | 4229 | 2.1% |
| 94105 | 8628 | |
| 94107 | 7706 | |
| 94108 | 5321 | 2.7% |
| 94109 | 11348 | |
| 94110 | 17838 | |
| 94111 | 5385 | 2.7% |
| 94112 | 7898 |
| Value | Count | Frequency (%) |
| 94158 | 1058 | 0.5% |
| 94134 | 2983 | 1.5% |
| 94133 | 7424 | |
| 94132 | 3507 | 1.8% |
| 94131 | 7665 | |
| 94130 | 81 | < 0.1% |
| 94129 | 23 | < 0.1% |
| 94127 | 4993 | |
| 94124 | 5266 | |
| 94123 | 9515 |
Location
Text
| Distinct | 57604 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 1700 |
| Missing (%) | 0.9% |
| Memory size | 18.3 MiB |
Length
| Max length | 41 |
|---|---|
| Median length | 40 |
| Mean length | 40.044278 |
| Min length | 35 |
Characters and Unicode
| Total characters | 7897132 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26164 ? |
|---|---|
| Unique (%) | 13.3% |
Sample
| 1st row | (37.79362102799777, -122.41488237355445) |
|---|---|
| 2nd row | (37.759041020475465, -122.50286985467523) |
| 3rd row | (37.73778863007536, -122.41197863877355) |
| 4th row | (37.78762264983362, -122.43099126735969) |
| 5th row | (37.75275550565926, -122.41707462095194) |
| Value | Count | Frequency (%) |
| 37.79226164705184 | 554 | 0.1% |
| 122.4034859571375 | 554 | 0.1% |
| 37.79294896659241 | 330 | 0.1% |
| 122.39809861435491 | 330 | 0.1% |
| 37.728556952954136 | 281 | 0.1% |
| 122.47676641508518 | 281 | 0.1% |
| 37.77523036414975 | 276 | 0.1% |
| 122.4174703200545 | 276 | 0.1% |
| 37.78977799888473 | 252 | 0.1% |
| 122.40173648131338 | 252 | 0.1% |
| Other values (115177) | 391034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Record ID
Real number (ℝ)
| Distinct | 198900 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1620463 × 1012 |
| Minimum | 1.2935322 × 1010 |
|---|---|
| Maximum | 1.4983421 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1.2935322 × 1010 |
|---|---|
| 5-th percentile | 1.3453409 × 1011 |
| Q1 | 1.3085657 × 1012 |
| median | 1.3718398 × 1012 |
| Q3 | 1.434998 × 1012 |
| 95-th percentile | 1.4859048 × 1012 |
| Maximum | 1.4983421 × 1012 |
| Range | 1.4854068 × 1012 |
| Interquartile range (IQR) | 1.2643222 × 1011 |
Descriptive statistics
| Standard deviation | 4.9182197 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.42323786 |
| Kurtosis | 0.55165918 |
| Mean | 1.1620463 × 1012 |
| Median Absolute Deviation (MAD) | 6.3217113 × 1010 |
| Skewness | -1.5726861 |
| Sum | 2.3114262 × 1017 |
| Variance | 2.4188885 × 1023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.415850502 × 1012 | 2 | < 0.1% |
| 1.317532663 × 1011 | 2 | < 0.1% |
| 1.448683508 × 1012 | 2 | < 0.1% |
| 1.394751213 × 1012 | 2 | < 0.1% |
| 1.475973855 × 1011 | 2 | < 0.1% |
| 1.301037451 × 1012 | 2 | < 0.1% |
| 1.410003156 × 1012 | 2 | < 0.1% |
| 1.350685167 × 1012 | 2 | < 0.1% |
| 1.344366188 × 1012 | 2 | < 0.1% |
| 1.414026241 × 1012 | 2 | < 0.1% |
| Other values (198890) | 198890 |
| Value | Count | Frequency (%) |
| 1.29353215 × 1010 | 1 | |
| 1.295722223 × 1010 | 1 | |
| 1.296226196 × 1010 | 1 | |
| 1.296342101 × 1010 | 1 | |
| 1.296629102 × 1010 | 1 | |
| 1.297286249 × 1010 | 1 | |
| 1.297668221 × 1010 | 1 | |
| 1.297846157 × 1010 | 1 | |
| 1.298230162 × 1010 | 1 | |
| 1.298784182 × 1010 | 1 |
| Value | Count | Frequency (%) |
| 1.498342128 × 1012 | 1 | |
| 1.498341156 × 1012 | 1 | |
| 1.498339194 × 1012 | 1 | |
| 1.498338347 × 1012 | 1 | |
| 1.498337117 × 1012 | 1 | |
| 1.498336196 × 1012 | 1 | |
| 1.498335409 × 1012 | 1 | |
| 1.498334222 × 1012 | 1 | |
| 1.498331399 × 1012 | 1 | |
| 1.498330476 × 1012 | 1 |
| Current Status | Estimated Cost | Existing Construction Type | Existing Construction Type Description | Existing Units | Neighborhoods - Analysis Boundaries | Number of Existing Stories | Number of Proposed Stories | Permit Type | Permit Type Definition | Plansets | Proposed Construction Type | Proposed Construction Type Description | Proposed Units | Record ID | Revised Cost | Street Number | Street Number Suffix | Street Suffix | Unit | Zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Current Status | 1.000 | 0.015 | 0.000 | 0.028 | 0.000 | 0.039 | 0.023 | 0.023 | 0.135 | 0.103 | 0.000 | 0.032 | 0.032 | 0.002 | 0.106 | 0.015 | 0.018 | 0.173 | 0.026 | 0.000 | 0.027 |
| Estimated Cost | 0.015 | 1.000 | -0.073 | 0.000 | 0.009 | 0.009 | 0.099 | 0.117 | -0.208 | 0.149 | 0.259 | 0.021 | 0.021 | 0.008 | 0.025 | 0.884 | -0.020 | 0.000 | 0.000 | 0.006 | -0.030 |
| Existing Construction Type | 0.000 | -0.073 | 1.000 | 0.000 | 0.263 | 0.000 | -0.620 | -0.624 | 0.006 | 0.000 | -0.346 | 0.000 | 0.000 | 0.252 | 0.091 | -0.081 | 0.221 | 1.000 | 0.000 | -0.145 | 0.487 |
| Existing Construction Type Description | 0.028 | 0.000 | 0.000 | 1.000 | 0.115 | 0.326 | 0.307 | 0.311 | 0.070 | 0.401 | 0.000 | 0.994 | 0.994 | 0.115 | 0.085 | 0.000 | 0.094 | 0.073 | 0.111 | 0.118 | 0.248 |
| Existing Units | 0.000 | 0.009 | 0.263 | 0.115 | 1.000 | 0.131 | 0.185 | 0.168 | 0.005 | 0.007 | -0.169 | 0.142 | 0.142 | 0.981 | 0.052 | -0.004 | 0.167 | 0.000 | 0.063 | 0.438 | 0.049 |
| Neighborhoods - Analysis Boundaries | 0.039 | 0.009 | 0.000 | 0.326 | 0.131 | 1.000 | 0.275 | 0.278 | 0.093 | 0.071 | 0.000 | 0.426 | 0.426 | 0.132 | 0.368 | 0.008 | 0.322 | 0.224 | 0.211 | 0.120 | 0.770 |
| Number of Existing Stories | 0.023 | 0.099 | -0.620 | 0.307 | 0.185 | 0.275 | 1.000 | 0.982 | 0.025 | 0.030 | 0.286 | 0.410 | 0.410 | 0.181 | -0.109 | 0.099 | -0.133 | 0.079 | 0.092 | 0.197 | -0.411 |
| Number of Proposed Stories | 0.023 | 0.117 | -0.624 | 0.311 | 0.168 | 0.278 | 0.982 | 1.000 | -0.021 | 0.031 | 0.311 | 0.409 | 0.409 | 0.194 | -0.106 | 0.110 | -0.128 | 0.068 | 0.092 | 0.196 | -0.413 |
| Permit Type | 0.135 | -0.208 | 0.006 | 0.070 | 0.005 | 0.093 | 0.025 | -0.021 | 1.000 | 1.000 | -0.285 | 0.057 | 0.057 | -0.069 | -0.013 | -0.243 | -0.005 | 0.204 | 0.058 | 0.064 | 0.001 |
| Permit Type Definition | 0.103 | 0.149 | 0.000 | 0.401 | 0.007 | 0.071 | 0.030 | 0.031 | 1.000 | 1.000 | 0.000 | 0.049 | 0.049 | 0.015 | 0.023 | 0.162 | 0.015 | 0.204 | 0.044 | 0.000 | 0.043 |
| Plansets | 0.000 | 0.259 | -0.346 | 0.000 | -0.169 | 0.000 | 0.286 | 0.311 | -0.285 | 0.000 | 1.000 | 0.000 | 0.000 | -0.133 | -0.015 | 0.233 | -0.064 | 1.000 | 0.000 | -0.189 | -0.204 |
| Proposed Construction Type | 0.032 | 0.021 | 0.000 | 0.994 | 0.142 | 0.426 | 0.410 | 0.409 | 0.057 | 0.049 | 0.000 | 1.000 | 1.000 | 0.143 | 0.085 | 0.017 | 0.121 | 0.054 | 0.148 | 0.133 | 0.306 |
| Proposed Construction Type Description | 0.032 | 0.021 | 0.000 | 0.994 | 0.142 | 0.426 | 0.410 | 0.409 | 0.057 | 0.049 | 0.000 | 1.000 | 1.000 | 0.143 | 0.085 | 0.017 | 0.121 | 0.054 | 0.148 | 0.133 | 0.306 |
| Proposed Units | 0.002 | 0.008 | 0.252 | 0.115 | 0.981 | 0.132 | 0.181 | 0.194 | -0.069 | 0.015 | -0.133 | 0.143 | 0.143 | 1.000 | 0.053 | -0.007 | 0.168 | 0.000 | 0.064 | 0.437 | 0.029 |
| Record ID | 0.106 | 0.025 | 0.091 | 0.085 | 0.052 | 0.368 | -0.109 | -0.106 | -0.013 | 0.023 | -0.015 | 0.085 | 0.085 | 0.053 | 1.000 | -0.015 | -0.023 | 0.284 | 0.094 | -0.230 | -0.003 |
| Revised Cost | 0.015 | 0.884 | -0.081 | 0.000 | -0.004 | 0.008 | 0.099 | 0.110 | -0.243 | 0.162 | 0.233 | 0.017 | 0.017 | -0.007 | -0.015 | 1.000 | -0.063 | 0.000 | 0.000 | 0.024 | -0.029 |
| Street Number | 0.018 | -0.020 | 0.221 | 0.094 | 0.167 | 0.322 | -0.133 | -0.128 | -0.005 | 0.015 | -0.064 | 0.121 | 0.121 | 0.168 | -0.023 | -0.063 | 1.000 | 0.104 | 0.119 | -0.005 | 0.151 |
| Street Number Suffix | 0.173 | 0.000 | 1.000 | 0.073 | 0.000 | 0.224 | 0.079 | 0.068 | 0.204 | 0.204 | 1.000 | 0.054 | 0.054 | 0.000 | 0.284 | 0.000 | 0.104 | 1.000 | 0.078 | 0.000 | 0.195 |
| Street Suffix | 0.026 | 0.000 | 0.000 | 0.111 | 0.063 | 0.211 | 0.092 | 0.092 | 0.058 | 0.044 | 0.000 | 0.148 | 0.148 | 0.064 | 0.094 | 0.000 | 0.119 | 0.078 | 1.000 | 0.079 | 0.247 |
| Unit | 0.000 | 0.006 | -0.145 | 0.118 | 0.438 | 0.120 | 0.197 | 0.196 | 0.064 | 0.000 | -0.189 | 0.133 | 0.133 | 0.437 | -0.230 | 0.024 | -0.005 | 0.000 | 0.079 | 1.000 | -0.060 |
| Zipcode | 0.027 | -0.030 | 0.487 | 0.248 | 0.049 | 0.770 | -0.411 | -0.413 | 0.001 | 0.043 | -0.204 | 0.306 | 0.306 | 0.029 | -0.003 | -0.029 | 0.151 | 0.195 | 0.247 | -0.060 | 1.000 |
| Permit Number | Permit Type | Permit Type Definition | Permit Creation Date | Block | Lot | Street Number | Street Number Suffix | Street Name | Street Suffix | Unit | Unit Suffix | Description | Current Status | Current Status Date | Filed Date | Issued Date | Completed Date | First Construction Document Date | Structural Notification | Number of Existing Stories | Number of Proposed Stories | Voluntary Soft-Story Retrofit | Fire Only Permit | Permit Expiration Date | Estimated Cost | Revised Cost | Existing Use | Existing Units | Proposed Use | Proposed Units | Plansets | TIDF Compliance | Existing Construction Type | Existing Construction Type Description | Proposed Construction Type | Proposed Construction Type Description | Site Permit | Supervisor District | Neighborhoods - Analysis Boundaries | Zipcode | Location | Record ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | M788927 | 8 | otc alterations permit | 05/23/2017 | 0215 | 001 | 1333 | NaN | jOnEs | St | NaN | NaN | street space | issued | 05/23/2017 | 05/23/2017 | 05/23/2017 | NaN | 05/23/2017 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | Nob Hill | 94109.0 | (37.79362102799777, -122.41488237355445) | 1464153232862 |
| 1 | 201305318356 | 8 | otc alterations permit | 05/31/2013 | 1810 | 017A | 1483 | NaN | 43rD | Av | NaN | NaN | remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting. | complete | 08/28/2013 | 05/31/2013 | 06/03/2013 | 08/28/2013 | 06/03/2013 | NaN | 2.0 | 2.0 | NaN | NaN | 05/29/2014 | 12000.0 | 12000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 4.0 | Sunset/Parkside | 94122.0 | (37.759041020475465, -122.50286985467523) | 1306559115258 |
| 2 | 201705106205 | 8 | otc alterations permit | 05/10/2017 | 5700 | 027 | 431 | NaN | pReNtIsS | St | NaN | NaN | replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window | issued | 05/11/2017 | 05/10/2017 | 05/11/2017 | NaN | 05/11/2017 | NaN | 2.0 | 2.0 | NaN | NaN | 05/06/2018 | 1000.0 | 2000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 9.0 | Bernal Heights | 94110.0 | (37.73778863007536, -122.41197863877355) | 1462579187173 |
| 3 | 201410279983 | 8 | otc alterations permit | 10/27/2014 | 0661 | 005 | 2020 | NaN | bUsH | St | NaN | NaN | two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units. | complete | 12/31/2014 | 10/27/2014 | 10/27/2014 | 12/31/2014 | 10/27/2014 | NaN | 2.0 | 2.0 | NaN | NaN | 10/22/2015 | 35000.0 | 35000.0 | 2 family dwelling | 2.0 | 2 family dwelling | 2.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 5.0 | Pacific Heights | 94115.0 | (37.78762264983362, -122.43099126735969) | 136037778128 |
| 4 | 201310280388 | 8 | otc alterations permit | 10/28/2013 | 3642 | 051A | 871 | NaN | cApP | St | NaN | NaN | reroofing | issued | 10/28/2013 | 10/28/2013 | 10/28/2013 | NaN | 10/28/2013 | NaN | 2.0 | 2.0 | NaN | NaN | 10/23/2014 | 9900.0 | 9900.0 | apartments | 4.0 | apartments | 4.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 9.0 | Mission | 94110.0 | (37.75275550565926, -122.41707462095194) | 1322242163712 |
| 5 | 201307161925 | 8 | otc alterations permit | 07/16/2013 | 3565 | 076 | 3479 | NaN | 16tH | St | NaN | NaN | to comply with physical inspection report #cc-7260 item #1 -all storage items are being removed. | complete | 10/08/2013 | 07/16/2013 | 07/16/2013 | 10/08/2013 | 07/16/2013 | NaN | 3.0 | 3.0 | NaN | NaN | 07/11/2014 | 7500.0 | 7500.0 | apartments | 3.0 | apartments | 3.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 8.0 | Castro/Upper Market | 94114.0 | (37.76416871595274, -122.43039745629406) | 1311167285194 |
| 6 | M501607 | 8 | otc alterations permit | 07/02/2014 | 3561 | 007 | 238 | NaN | nOe | St | NaN | NaN | street space | issued | 07/02/2014 | 07/02/2014 | 07/02/2014 | NaN | 07/02/2014 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8.0 | Castro/Upper Market | 94114.0 | (37.76519640087225, -122.4334386869886) | 1347642247334 |
| 7 | M787887 | 8 | otc alterations permit | 05/19/2017 | 0654 | 009 | 2338 | NaN | pInE | St | NaN | NaN | street space permit | issued | 05/19/2017 | 05/19/2017 | 05/19/2017 | NaN | 05/19/2017 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | Pacific Heights | 94115.0 | (37.78814050763782, -122.43440743226256) | 1463876236318 |
| 8 | 201404113025 | 8 | otc alterations permit | 04/11/2014 | 3740 | 029 | 126 | NaN | fOlSoM | St | NaN | NaN | existing office and storage facility. new partitions, restroom upgrade. electrical on a separate permit | complete | 10/02/2014 | 04/11/2014 | 04/25/2014 | 10/02/2014 | 04/25/2014 | NaN | 1.0 | 1.0 | NaN | NaN | 04/09/2017 | 125000.0 | 125000.0 | office | NaN | office | NaN | 2.0 | NaN | 3.0 | constr type 3 | 3.0 | constr type 3 | NaN | 6.0 | Financial District/South Beach | 94105.0 | (37.78992343288329, -122.3915399961996) | 1338371165676 |
| 9 | 201702109134 | 8 | otc alterations permit | 02/10/2017 | 0195 | 001 | 735 | NaN | mOnTgOmErY | St | NaN | NaN | basement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13 | complete | 03/09/2017 | 02/10/2017 | 02/10/2017 | 03/09/2017 | 02/10/2017 | NaN | 4.0 | 4.0 | NaN | NaN | 02/05/2018 | 1.0 | 1.0 | retail sales | 0.0 | retail sales | 0.0 | 2.0 | NaN | 3.0 | constr type 3 | 3.0 | constr type 3 | NaN | 3.0 | Chinatown | 94111.0 | (37.79621627942539, -122.40375479881872) | 145294162223 |
| Permit Number | Permit Type | Permit Type Definition | Permit Creation Date | Block | Lot | Street Number | Street Number Suffix | Street Name | Street Suffix | Unit | Unit Suffix | Description | Current Status | Current Status Date | Filed Date | Issued Date | Completed Date | First Construction Document Date | Structural Notification | Number of Existing Stories | Number of Proposed Stories | Voluntary Soft-Story Retrofit | Fire Only Permit | Permit Expiration Date | Estimated Cost | Revised Cost | Existing Use | Existing Units | Proposed Use | Proposed Units | Plansets | TIDF Compliance | Existing Construction Type | Existing Construction Type Description | Proposed Construction Type | Proposed Construction Type Description | Site Permit | Supervisor District | Neighborhoods - Analysis Boundaries | Zipcode | Location | Record ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 198900 | 201506027767 | 8 | otc alterations permit | 06/02/2015 | 7101A | 007 | 736 | NaN | hUrOn | Av | NaN | NaN | reroofing | complete | 03/11/2016 | 06/02/2015 | 06/02/2015 | 03/11/2016 | 06/02/2015 | NaN | 2.0 | 2.0 | NaN | NaN | 05/27/2016 | 6000.0 | 6000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 11.0 | Outer Mission | 94112.0 | (37.71192805393076, -122.4500944316179) | 1383549221502 |
| 198901 | M871027 | 8 | otc alterations permit | 12/28/2017 | 1870 | 023 | 1514 | NaN | 25tH | Av | NaN | NaN | street space | issued | 12/28/2017 | 12/28/2017 | 12/28/2017 | NaN | 12/28/2017 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | Sunset/Parkside | 94122.0 | (37.75921574765919, -122.48300451049278) | 1492023118112 |
| 198902 | 201609208175 | 8 | otc alterations permit | 09/20/2016 | 2130A | 006G | 78 | NaN | cRaGmOnT | Av | NaN | NaN | replace (e) tub with walk in tub, 20 amp circuit, gfci outlet | complete | 09/28/2016 | 09/20/2016 | 09/20/2016 | 09/28/2016 | 09/20/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 09/15/2017 | 17900.0 | 17900.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 7.0 | Inner Sunset | 94116.0 | (37.74973733662819, -122.4671301493082) | 1438114126978 |
| 198903 | 201407161416 | 8 | otc alterations permit | 07/16/2014 | 2528 | 024 | 66 | NaN | cReStLaKe | Dr | NaN | NaN | cut a door and a staircase for access to backyard.build deck next to staircase. | complete | 01/23/2015 | 07/16/2014 | 10/28/2014 | 01/23/2015 | 10/28/2014 | Y | 2.0 | 2.0 | NaN | NaN | 10/23/2015 | 4500.0 | 6000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 4.0 | Sunset/Parkside | 94132.0 | (37.73542953855242, -122.48149902038024) | 1349089138746 |
| 198904 | M651047 | 8 | otc alterations permit | 12/30/2015 | 6176 | 008 | 342 | NaN | hArKnEsS | Av | NaN | NaN | street space | issued | 12/30/2015 | 12/30/2015 | 12/30/2015 | NaN | 12/30/2015 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 10.0 | Visitacion Valley | 94134.0 | (37.71765127619624, -122.40342209330782) | 1407979197645 |
| 198905 | 201604053958 | 3 | additions alterations or repairs | 04/05/2016 | 7295 | 021 | 3251 | NaN | 20tH | Av | NaN | NaN | ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771 | complete | 11/22/2016 | 04/05/2016 | 07/18/2016 | 11/22/2016 | 07/18/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 07/03/2019 | 325000.0 | 928009.2 | retail sales | 0.0 | retail sales | 0.0 | 2.0 | NaN | 2.0 | constr type 2 | 2.0 | constr type 2 | NaN | 7.0 | Lakeshore | 94132.0 | (37.728556952954136, -122.47676641508518) | 1418495226171 |
| 198906 | 201510270880 | 8 | otc alterations permit | 10/27/2015 | 4009 | 001A | 1919 | NaN | mArIpOsA | St | NaN | NaN | install new 2" underground combination fire main. ref app#201402108156 | issued | 10/27/2015 | 10/27/2015 | 10/27/2015 | NaN | 10/27/2015 | NaN | 3.0 | 3.0 | NaN | Y | 10/21/2016 | 1200.0 | 9600.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 10.0 | Potrero Hill | 94107.0 | (37.76328445631136, -122.40287014554292) | 1400885168656 |
| 198907 | 201607293741 | 8 | otc alterations permit | 07/29/2016 | 4262 | 020 | 1341 | NaN | sAn bRuNo | Av | NaN | NaN | replace rotten wooden moldings in kind front stairs less than 50% replace | issued | 07/29/2016 | 07/29/2016 | 07/29/2016 | NaN | 07/29/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 07/24/2017 | 1900.0 | 1900.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 10.0 | Mission | 94110.0 | (37.75260530951628, -122.40400191084352) | 1431897172643 |
| 198908 | 201701066691 | 8 | otc alterations permit | 01/06/2017 | 0146 | 007 | 660 | NaN | bRoAdWaY | NaN | NaN | NaN | revision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377 | issued | 02/01/2017 | 01/06/2017 | 02/01/2017 | NaN | 02/01/2017 | NaN | 2.0 | 2.0 | NaN | NaN | 01/27/2018 | 1.0 | 1.0 | retail sales | 9.0 | retail sales | 9.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 3.0 | Chinatown | 94133.0 | (37.79800446861674, -122.4080339831039) | 1449660232064 |
| 198909 | 201604255599 | 8 | otc alterations permit | 04/25/2016 | 3708 | 056 | 525 | NaN | mArKeT | St | NaN | NaN | 16th floor - (4) evacuation plans. | issued | 04/25/2016 | 04/25/2016 | 04/25/2016 | NaN | 04/25/2016 | NaN | 38.0 | 38.0 | NaN | Y | 04/20/2017 | 1600.0 | 1600.0 | office | 0.0 | office | 0.0 | 2.0 | NaN | 1.0 | constr type 1 | 1.0 | constr type 1 | NaN | 6.0 | Financial District/South Beach | 94105.0 | (37.79040639954478, -122.39927546096968) | 1420790164534 |